package com.cy.pj.sys.dao;

import com.cy.pj.sys.pojo.SysStudent;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface SysStudentDao {
    /**
     * 模糊查询
     * 查询姓名,邮箱,产品类型
     * @return
     */
    List<SysStudent> selectStu(SysStudent sysStudent);



//    select type from sys_product where  id = (select  sys.pro_id from sys_student  s left join sys_student_product sys on s.id=sys.stu_id  where s.id = 1)
    /**
     * 根据id查询
     * @param id
     * @return
     */
    SysStudent selectById(Long id);

    /**
     * 增加
     * @param sysStudent
     * @return
     */
    Integer insertStu(SysStudent sysStudent);

    /**
     * 修改
     * @param sysStudent
     * @return
     */
    Integer updateStu(SysStudent sysStudent);


    Integer deleteById(Long id);
}
